package com.manage.mapper;

import com.manage.pojo.UserExtensions;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;
import org.springframework.stereotype.Repository;
import tk.mybatis.mapper.common.Mapper;

@Repository
public interface UserExtensionsMapper extends Mapper<UserExtensions> {

    @Select("select  e.* from tb_user_extensions e left join tb_user_base_extensions be on be.extensions_id=e.id where be.base_job_id=#{jobNumber}")
    UserExtensions queryByJobNumber(@Param("jobNumber") Long jobNumber);
}
